<?php
	session_start();
	if(!isset($_SESSION['user'])||$_SESSION['pos']!="Manager")
	{
		header("Location: index.php");
	}
	require_once("function.php");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<title>APO Cooperative Database System - Add Employee</title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" type="text/css" href="style.css" />
<link rel="stylesheet" type="text/css" href="css/ui-lightness/jquery-ui-1.8rc2.custom.css" />
</head>
<body>
<div class="container ui-corner-all">
	<div class="header ui-corner-top">
  <h1>APO Cooperative Database System</h1>
</div>
<div class="divider"></div>
  <div class="wrapper">
    <div class="content">
      	       	<?php
					$con = connectToDB();
					
					$result = mysql_query("select * from employee where Emp_no NOT IN (select EMPLOYEE_Emp_no from manages) and Pos <> 'Manager'");
					if(mysql_num_rows($result)!=0)
					{
						echo "<form action=\"employeeRecordController.php\" method=\"post\">
								Employee Number: 
            					<select name=\"employeeNumber\">";
						while($row = mysql_fetch_array($result))
						{
							echo "<option value=".$row['Emp_no'].">".$row['First_name']." ".$row['Last_name']."</option>";
						}
						echo "</select>
           						<br/>
            					<input type=\"hidden\" name=\"managerNumber\" value=\"".$_SESSION['user']."\" />
								<input type=\"submit\" value=\"Add Employee\"/>
							</form>";
					}
					else
						echo "<div class=\"ui-state-error\" style=\"width: 90%\">No employee available</div>";
				?>
           
    </div>
    </div>
  <div class="navigation ui-corner-all">
    <div class="navheader ui-corner-top"></div>
  	<div class="userstat">
    <?php
    	echo "<p>You are logged in as: <br/>".$_SESSION['name']."<br/></p>";
			echo "<a href=\"\">Edit</a> your profile<br />";
			echo "<a href=\"logOut.php\">Log Out</a><br />";
	?>
    </div>
    </div>
    <div class="extra ui-corner-all">
    <div class="navheader ui-corner-top"></div>
    <div class="userstat">
    <a href="managerpage.php">Back to profile page</a><br />
    	<a href="addEmployeeView.php">Add Employee</a><br />
        <a href="viewEmployeesView.php">View Employees</a><br />
        <a href="viewOtherEmployeesView.php">View Other Employees</a><br />
        <a href="movePlanHolderView.php">Move Planholders</a>
    </div>
    </div>
    <div class="footer ui-corner-bottom">
    <a href="#">Contact Us</a> | <a href="#">Terms of Use</a> | <a href="#">Trademarks</a> | <a href="#">Privacy Statement</a><br />
    Copyright &copy; 2009 . All Rights Reserved.
  </div>
</div>
</body>
</html>

